set maxvar 25000


/* Table 3 */


import sas using "W:\Tutkimusprojektit\Kirjanpito\Dokumentaatio\JAR\Datat\stata_talous_011025.sas7bdat", clear
ebalance P_D_talous_kaikki_2 P_D_muu_rikos_4_2 P_BUSINESS_SOCIALDEG P_LN_EDULEVEL P_D_MARITAL_STATUS P_LN_CUM_SUM_DIVORCE P_LN_TOTALINCOME2 P_D_CUM_SUBSTANCE P_D_CUM_ALL_BUT_SUBS D_Muu_rikos_4 MALE LN_AGE BUSINESS_SOCIALDEG LN_EDULEVEL D_MARITAL_STATUS LN_CUM_SUM_DIVORCE LN_TOTALINCOME2 D_CUM_SUBSTANCE D_CUM_ALL_BUT_SUBS D_FMOB LN_NUM_POSITIONS Mean_OMAVARAISUUS2 Mean_LNTASE2 Mean_ROA2 Mean_LN_Boardsize Mean_Current_Ratio2 i.YEAR i.Industry_2002_3, targets(3) maxiter(25)
reg D_Vaste_talous_kaikki P_D_talous_kaikki_2 P_D_muu_rikos_4_2 P_BUSINESS_SOCIALDEG P_LN_EDULEVEL P_D_MARITAL_STATUS P_LN_CUM_SUM_DIVORCE P_LN_TOTALINCOME2 P_D_CUM_SUBSTANCE P_D_CUM_ALL_BUT_SUBS D_Muu_rikos_4 MALE LN_AGE BUSINESS_SOCIALDEG LN_EDULEVEL D_MARITAL_STATUS LN_CUM_SUM_DIVORCE LN_TOTALINCOME2 D_CUM_SUBSTANCE D_CUM_ALL_BUT_SUBS D_FMOB LN_NUM_POSITIONS Mean_OMAVARAISUUS2 Mean_LNTASE2 Mean_ROA2 Mean_LN_Boardsize Mean_Current_Ratio2 i.MAAKUNTA i.YEAR i.Industry_2002_3 [aweight=_webal], cluster(ID)
ereturn list r2_a
tabulate D_Vaste_talous_kaikki P_D_talous_kaikki_2 

ebalance P_D_talous_kaikki_2 P_D_muu_rikos_4_2 P_BUSINESS_SOCIALDEG P_LN_EDULEVEL P_D_MARITAL_STATUS P_LN_CUM_SUM_DIVORCE P_LN_TOTALINCOME2 P_D_CUM_SUBSTANCE P_D_CUM_ALL_BUT_SUBS D_Muu_rikos_4 MALE LN_AGE BUSINESS_SOCIALDEG LN_EDULEVEL D_MARITAL_STATUS LN_CUM_SUM_DIVORCE LN_TOTALINCOME2 D_CUM_SUBSTANCE D_CUM_ALL_BUT_SUBS D_FMOB LN_NUM_POSITIONS Mean_OMAVARAISUUS2 Mean_LNTASE2 Mean_ROA2 Mean_LN_Boardsize Mean_Current_Ratio2 i.YEAR i.Industry_2002_3 if Finan_mukaan == 1, targets(3) maxiter(25)
reg D_Vaste_Finan_rep_fraud P_D_talous_kaikki_2 P_D_muu_rikos_4_2 P_BUSINESS_SOCIALDEG P_LN_EDULEVEL P_D_MARITAL_STATUS P_LN_CUM_SUM_DIVORCE P_LN_TOTALINCOME2 P_D_CUM_SUBSTANCE P_D_CUM_ALL_BUT_SUBS D_Muu_rikos_4 MALE LN_AGE BUSINESS_SOCIALDEG LN_EDULEVEL D_MARITAL_STATUS LN_CUM_SUM_DIVORCE LN_TOTALINCOME2 D_CUM_SUBSTANCE D_CUM_ALL_BUT_SUBS D_FMOB LN_NUM_POSITIONS Mean_OMAVARAISUUS2 Mean_LNTASE2 Mean_ROA2 Mean_LN_Boardsize Mean_Current_Ratio2 i.MAAKUNTA i.YEAR i.Industry_2002_3 [aweight=_webal], cluster(ID)
ereturn list r2_a
tabulate D_Vaste_talous_kaikki P_D_talous_kaikki_2 if Finan_mukaan == 1

ebalance P_D_talous_kaikki_2 P_D_muu_rikos_4_2 P_BUSINESS_SOCIALDEG P_LN_EDULEVEL P_D_MARITAL_STATUS P_LN_CUM_SUM_DIVORCE P_LN_TOTALINCOME2 P_D_CUM_SUBSTANCE P_D_CUM_ALL_BUT_SUBS D_Muu_rikos_4 MALE LN_AGE BUSINESS_SOCIALDEG LN_EDULEVEL D_MARITAL_STATUS LN_CUM_SUM_DIVORCE LN_TOTALINCOME2 D_CUM_SUBSTANCE D_CUM_ALL_BUT_SUBS D_FMOB LN_NUM_POSITIONS Mean_OMAVARAISUUS2 Mean_LNTASE2 Mean_ROA2 Mean_LN_Boardsize Mean_Current_Ratio2 i.YEAR i.Industry_2002_3 if Tax_mukaan == 1, targets(3) maxiter(25)
reg D_Vaste_Tax_relat_fraud P_D_talous_kaikki_2 P_D_muu_rikos_4_2 P_BUSINESS_SOCIALDEG P_LN_EDULEVEL P_D_MARITAL_STATUS P_LN_CUM_SUM_DIVORCE P_LN_TOTALINCOME2 P_D_CUM_SUBSTANCE P_D_CUM_ALL_BUT_SUBS D_Muu_rikos_4 MALE LN_AGE BUSINESS_SOCIALDEG LN_EDULEVEL D_MARITAL_STATUS LN_CUM_SUM_DIVORCE LN_TOTALINCOME2 D_CUM_SUBSTANCE D_CUM_ALL_BUT_SUBS D_FMOB LN_NUM_POSITIONS Mean_OMAVARAISUUS2 Mean_LNTASE2 Mean_ROA2 Mean_LN_Boardsize Mean_Current_Ratio2 i.MAAKUNTA i.YEAR i.Industry_2002_3 [aweight=_webal], cluster(ID)
ereturn list r2_a
tabulate D_Vaste_talous_kaikki P_D_talous_kaikki_2 if Tax_mukaan == 1

ebalance P_D_talous_kaikki_2 P_D_muu_rikos_4_2 P_BUSINESS_SOCIALDEG P_LN_EDULEVEL P_D_MARITAL_STATUS P_LN_CUM_SUM_DIVORCE P_LN_TOTALINCOME2 P_D_CUM_SUBSTANCE P_D_CUM_ALL_BUT_SUBS D_Muu_rikos_4 MALE LN_AGE BUSINESS_SOCIALDEG LN_EDULEVEL D_MARITAL_STATUS LN_CUM_SUM_DIVORCE LN_TOTALINCOME2 D_CUM_SUBSTANCE D_CUM_ALL_BUT_SUBS D_FMOB LN_NUM_POSITIONS Mean_OMAVARAISUUS2 Mean_LNTASE2 Mean_ROA2 Mean_LN_Boardsize Mean_Current_Ratio2 i.YEAR i.Industry_2002_3 if Other_mukaan == 1, targets(3) maxiter(25)
reg D_Vaste_Other_finan_crime P_D_talous_kaikki_2 P_D_muu_rikos_4_2 P_BUSINESS_SOCIALDEG P_LN_EDULEVEL P_D_MARITAL_STATUS P_LN_CUM_SUM_DIVORCE P_LN_TOTALINCOME2 P_D_CUM_SUBSTANCE P_D_CUM_ALL_BUT_SUBS D_Muu_rikos_4 MALE LN_AGE BUSINESS_SOCIALDEG LN_EDULEVEL D_MARITAL_STATUS LN_CUM_SUM_DIVORCE LN_TOTALINCOME2 D_CUM_SUBSTANCE D_CUM_ALL_BUT_SUBS D_FMOB LN_NUM_POSITIONS Mean_OMAVARAISUUS2 Mean_LNTASE2 Mean_ROA2 Mean_LN_Boardsize Mean_Current_Ratio2 i.MAAKUNTA i.YEAR i.Industry_2002_3 [aweight=_webal], cluster(ID)
ereturn list r2_a
tabulate D_Vaste_talous_kaikki P_D_talous_kaikki_2 if Other_mukaan == 1


/* Table 4 */


import sas using "W:\Tutkimusprojektit\Kirjanpito\Dokumentaatio\JAR\Datat\stata_talous_011025.sas7bdat", clear
ebalance P_D_talous_kaikki_2 P_D_muu_rikos_4_2 P_BUSINESS_SOCIALDEG P_LN_EDULEVEL P_D_MARITAL_STATUS P_LN_CUM_SUM_DIVORCE P_LN_TOTALINCOME2 P_D_CUM_SUBSTANCE P_D_CUM_ALL_BUT_SUBS D_Muu_rikos_4 MALE LN_AGE BUSINESS_SOCIALDEG LN_EDULEVEL D_MARITAL_STATUS LN_CUM_SUM_DIVORCE LN_TOTALINCOME2 D_CUM_SUBSTANCE D_CUM_ALL_BUT_SUBS D_FMOB LN_NUM_POSITIONS Mean_OMAVARAISUUS2 Mean_LNTASE2 Mean_ROA2 Mean_LN_Boardsize Mean_Current_Ratio2 i.YEAR i.Industry_2002_3, targets(3) maxiter(25)
reg D_Vaste_talous_kaikki P_D_Talous_kaikki_sakko_2 P_D_Talous_kaikki_vankeus_2 P_D_muu_rikos_4_2 P_BUSINESS_SOCIALDEG P_LN_EDULEVEL P_D_MARITAL_STATUS P_LN_CUM_SUM_DIVORCE P_LN_TOTALINCOME2 P_D_CUM_SUBSTANCE P_D_CUM_ALL_BUT_SUBS D_Muu_rikos_4 MALE LN_AGE BUSINESS_SOCIALDEG LN_EDULEVEL D_MARITAL_STATUS LN_CUM_SUM_DIVORCE LN_TOTALINCOME2 D_CUM_SUBSTANCE D_CUM_ALL_BUT_SUBS D_FMOB LN_NUM_POSITIONS Mean_OMAVARAISUUS2 Mean_LNTASE2 Mean_ROA2 Mean_LN_Boardsize Mean_Current_Ratio2 i.MAAKUNTA i.YEAR i.Industry_2002_3 [aweight=_webal], cluster(ID)
ereturn list r2_a
tabulate D_Vaste_talous_kaikki P_D_Talous_kaikki_sakko_2
tabulate D_Vaste_talous_kaikki P_D_Talous_kaikki_vankeus_2 
test P_D_Talous_kaikki_vankeus_2 - P_D_Talous_kaikki_sakko_2 = 0

ebalance P_D_talous_kaikki_2 P_D_muu_rikos_4_2 P_BUSINESS_SOCIALDEG P_LN_EDULEVEL P_D_MARITAL_STATUS P_LN_CUM_SUM_DIVORCE P_LN_TOTALINCOME2 P_D_CUM_SUBSTANCE P_D_CUM_ALL_BUT_SUBS D_Muu_rikos_4 MALE LN_AGE BUSINESS_SOCIALDEG LN_EDULEVEL D_MARITAL_STATUS LN_CUM_SUM_DIVORCE LN_TOTALINCOME2 D_CUM_SUBSTANCE D_CUM_ALL_BUT_SUBS D_FMOB LN_NUM_POSITIONS Mean_OMAVARAISUUS2 Mean_LNTASE2 Mean_ROA2 Mean_LN_Boardsize Mean_Current_Ratio2 i.YEAR i.Industry_2002_3 if Finan_mukaan == 1, targets(3) maxiter(25)
reg D_Vaste_Finan_rep_fraud P_D_Talous_kaikki_sakko_2 P_D_Talous_kaikki_vankeus_2 P_D_muu_rikos_4_2 P_BUSINESS_SOCIALDEG P_LN_EDULEVEL P_D_MARITAL_STATUS P_LN_CUM_SUM_DIVORCE P_LN_TOTALINCOME2 P_D_CUM_SUBSTANCE P_D_CUM_ALL_BUT_SUBS D_Muu_rikos_4 MALE LN_AGE BUSINESS_SOCIALDEG LN_EDULEVEL D_MARITAL_STATUS LN_CUM_SUM_DIVORCE LN_TOTALINCOME2 D_CUM_SUBSTANCE D_CUM_ALL_BUT_SUBS D_FMOB LN_NUM_POSITIONS Mean_OMAVARAISUUS2 Mean_LNTASE2 Mean_ROA2 Mean_LN_Boardsize Mean_Current_Ratio2 i.MAAKUNTA i.YEAR i.Industry_2002_3 [aweight=_webal], cluster(ID)
ereturn list r2_a
tabulate D_Vaste_talous_kaikki P_D_Talous_kaikki_sakko_2 if Finan_mukaan == 1
tabulate D_Vaste_talous_kaikki P_D_Talous_kaikki_vankeus_2 if Finan_mukaan == 1
test P_D_Talous_kaikki_vankeus_2 - P_D_Talous_kaikki_sakko_2 = 0

ebalance P_D_talous_kaikki_2 P_D_muu_rikos_4_2 P_BUSINESS_SOCIALDEG P_LN_EDULEVEL P_D_MARITAL_STATUS P_LN_CUM_SUM_DIVORCE P_LN_TOTALINCOME2 P_D_CUM_SUBSTANCE P_D_CUM_ALL_BUT_SUBS D_Muu_rikos_4 MALE LN_AGE BUSINESS_SOCIALDEG LN_EDULEVEL D_MARITAL_STATUS LN_CUM_SUM_DIVORCE LN_TOTALINCOME2 D_CUM_SUBSTANCE D_CUM_ALL_BUT_SUBS D_FMOB LN_NUM_POSITIONS Mean_OMAVARAISUUS2 Mean_LNTASE2 Mean_ROA2 Mean_LN_Boardsize Mean_Current_Ratio2 i.YEAR i.Industry_2002_3 if Tax_mukaan == 1, targets(3) maxiter(25)
reg D_Vaste_Tax_relat_fraud P_D_Talous_kaikki_sakko_2 P_D_Talous_kaikki_vankeus_2 P_BUSINESS_SOCIALDEG P_LN_EDULEVEL P_D_MARITAL_STATUS P_LN_CUM_SUM_DIVORCE P_LN_TOTALINCOME2 P_D_CUM_SUBSTANCE P_D_CUM_ALL_BUT_SUBS D_Muu_rikos_4 MALE LN_AGE BUSINESS_SOCIALDEG LN_EDULEVEL D_MARITAL_STATUS LN_CUM_SUM_DIVORCE LN_TOTALINCOME2 D_CUM_SUBSTANCE D_CUM_ALL_BUT_SUBS D_FMOB LN_NUM_POSITIONS Mean_OMAVARAISUUS2 Mean_LNTASE2 Mean_ROA2 Mean_LN_Boardsize Mean_Current_Ratio2 i.MAAKUNTA i.YEAR i.Industry_2002_3 [aweight=_webal], cluster(ID)
ereturn list r2_a
tabulate D_Vaste_talous_kaikki P_D_Talous_kaikki_sakko_2 if Tax_mukaan == 1
tabulate D_Vaste_talous_kaikki P_D_Talous_kaikki_vankeus_2 if Tax_mukaan == 1
test P_D_Talous_kaikki_vankeus_2 - P_D_Talous_kaikki_sakko_2 = 0

ebalance P_D_talous_kaikki_2 P_D_muu_rikos_4_2 P_BUSINESS_SOCIALDEG P_LN_EDULEVEL P_D_MARITAL_STATUS P_LN_CUM_SUM_DIVORCE P_LN_TOTALINCOME2 P_D_CUM_SUBSTANCE P_D_CUM_ALL_BUT_SUBS D_Muu_rikos_4 MALE LN_AGE BUSINESS_SOCIALDEG LN_EDULEVEL D_MARITAL_STATUS LN_CUM_SUM_DIVORCE LN_TOTALINCOME2 D_CUM_SUBSTANCE D_CUM_ALL_BUT_SUBS D_FMOB LN_NUM_POSITIONS Mean_OMAVARAISUUS2 Mean_LNTASE2 Mean_ROA2 Mean_LN_Boardsize Mean_Current_Ratio2 i.YEAR i.Industry_2002_3 if Other_mukaan == 1, targets(3) maxiter(25)
reg D_Vaste_Other_finan_crime P_D_Talous_kaikki_sakko_2 P_D_Talous_kaikki_vankeus_2 P_D_muu_rikos_4_2 P_BUSINESS_SOCIALDEG P_LN_EDULEVEL P_D_MARITAL_STATUS P_LN_CUM_SUM_DIVORCE P_LN_TOTALINCOME2 P_D_CUM_SUBSTANCE P_D_CUM_ALL_BUT_SUBS D_Muu_rikos_4 MALE LN_AGE BUSINESS_SOCIALDEG LN_EDULEVEL D_MARITAL_STATUS LN_CUM_SUM_DIVORCE LN_TOTALINCOME2 D_CUM_SUBSTANCE D_CUM_ALL_BUT_SUBS D_FMOB LN_NUM_POSITIONS Mean_OMAVARAISUUS2 Mean_LNTASE2 Mean_ROA2 Mean_LN_Boardsize Mean_Current_Ratio2 i.MAAKUNTA i.YEAR i.Industry_2002_3 [aweight=_webal], cluster(ID)
ereturn list r2_a
tabulate D_Vaste_talous_kaikki P_D_Talous_kaikki_sakko_2 if Other_mukaan == 1
tabulate D_Vaste_talous_kaikki P_D_Talous_kaikki_vankeus_2 if Other_mukaan == 1
test P_D_Talous_kaikki_vankeus_2 - P_D_Talous_kaikki_sakko_2 = 0


/* Table 5A */


import sas using "W:\Tutkimusprojektit\Kirjanpito\Dokumentaatio\JAR\Datat\statadata_fmob_firm_0_011025.sas7bdat", clear
ebalance P_D_talous_kaikki_2 P_D_muu_rikos_4_2 P_BUSINESS_SOCIALDEG P_LN_EDULEVEL P_D_MARITAL_STATUS P_LN_CUM_SUM_DIVORCE P_LN_TOTALINCOME2 P_D_CUM_SUBSTANCE P_D_CUM_ALL_BUT_SUBS D_Muu_rikos_4 MALE LN_AGE BUSINESS_SOCIALDEG LN_EDULEVEL D_MARITAL_STATUS LN_CUM_SUM_DIVORCE LN_TOTALINCOME2 D_CUM_SUBSTANCE D_CUM_ALL_BUT_SUBS D_FMOB LN_NUM_POSITIONS Mean_OMAVARAISUUS2 Mean_LNTASE2 Mean_ROA2 Mean_LN_Boardsize Mean_Current_Ratio2 i.YEAR i.Industry_2002_3, targets(3) maxiter(25)
reg D_Vaste_talous_kaikki P_D_talous_kaikki_2 P_D_muu_rikos_4_2 P_BUSINESS_SOCIALDEG P_LN_EDULEVEL P_D_MARITAL_STATUS P_LN_CUM_SUM_DIVORCE P_LN_TOTALINCOME2 P_D_CUM_SUBSTANCE P_D_CUM_ALL_BUT_SUBS D_Muu_rikos_4 MALE LN_AGE BUSINESS_SOCIALDEG LN_EDULEVEL D_MARITAL_STATUS LN_CUM_SUM_DIVORCE LN_TOTALINCOME2 D_CUM_SUBSTANCE D_CUM_ALL_BUT_SUBS D_FMOB LN_NUM_POSITIONS Mean_OMAVARAISUUS2 Mean_LNTASE2 Mean_ROA2 Mean_LN_Boardsize Mean_Current_Ratio2 i.MAAKUNTA i.YEAR i.Industry_2002_3 [aweight=_webal], cluster(ID)
ereturn list r2_a
tabulate D_Vaste_talous_kaikki P_D_talous_kaikki_2

import sas using "W:\Tutkimusprojektit\Kirjanpito\Dokumentaatio\JAR\Datat\stata_talous_011025.sas7bdat", clear
ebalance P_D_talous_kaikki_2 Mean_Mean_D_talous_kaikki Mean_Mean_D_muu_rikos_4 Mean_CEO_Duality P_D_muu_rikos_4_2 P_BUSINESS_SOCIALDEG P_LN_EDULEVEL P_D_MARITAL_STATUS P_LN_CUM_SUM_DIVORCE P_LN_TOTALINCOME2 P_D_CUM_SUBSTANCE P_D_CUM_ALL_BUT_SUBS D_Muu_rikos_4 MALE LN_AGE BUSINESS_SOCIALDEG LN_EDULEVEL D_MARITAL_STATUS LN_CUM_SUM_DIVORCE LN_TOTALINCOME2 D_CUM_SUBSTANCE D_CUM_ALL_BUT_SUBS D_FMOB LN_NUM_POSITIONS Mean_OMAVARAISUUS2 Mean_LNTASE2 Mean_ROA2 Mean_LN_Boardsize Mean_Current_Ratio2 i.YEAR i.Industry_2002_3, targets(3) maxiter(25)
reg D_Vaste_talous_kaikki P_D_talous_kaikki_2 Mean_Mean_D_talous_kaikki Mean_Mean_D_muu_rikos_4 Mean_CEO_Duality P_D_muu_rikos_4_2 P_BUSINESS_SOCIALDEG P_LN_EDULEVEL P_D_MARITAL_STATUS P_LN_CUM_SUM_DIVORCE P_LN_TOTALINCOME2 P_D_CUM_SUBSTANCE P_D_CUM_ALL_BUT_SUBS D_Muu_rikos_4 MALE LN_AGE BUSINESS_SOCIALDEG LN_EDULEVEL D_MARITAL_STATUS LN_CUM_SUM_DIVORCE LN_TOTALINCOME2 D_CUM_SUBSTANCE D_CUM_ALL_BUT_SUBS D_FMOB LN_NUM_POSITIONS Mean_OMAVARAISUUS2 Mean_LNTASE2 Mean_ROA2 Mean_LN_Boardsize Mean_Current_Ratio2 i.MAAKUNTA i.YEAR i.Industry_2002_3 [aweight=_webal], cluster(ID)
ereturn list r2_a
tabulate D_Vaste_talous_kaikki P_D_talous_kaikki_2

ebalance P_D_talous_kaikki_2 Mean_Mean_D_talous_kaikki Mean_Mean_D_muu_rikos_4 Mean_CEO_Duality P_D_muu_rikos_4_2 P_BUSINESS_SOCIALDEG P_LN_EDULEVEL P_D_MARITAL_STATUS P_LN_CUM_SUM_DIVORCE P_LN_TOTALINCOME2 P_D_CUM_SUBSTANCE P_D_CUM_ALL_BUT_SUBS D_Muu_rikos_4 MALE LN_AGE BUSINESS_SOCIALDEG LN_EDULEVEL D_MARITAL_STATUS LN_CUM_SUM_DIVORCE LN_TOTALINCOME2 D_CUM_SUBSTANCE D_CUM_ALL_BUT_SUBS D_FMOB LN_NUM_POSITIONS Mean_OMAVARAISUUS2 Mean_LNTASE2 Mean_ROA2 Mean_LN_Boardsize Mean_Current_Ratio2 i.YEAR i.Industry_2002_3 if Assets_3lk == 0, targets(3) maxiter(25)
reg D_Vaste_talous_kaikki P_D_talous_kaikki_2 Mean_Mean_D_talous_kaikki Mean_Mean_D_muu_rikos_4 Mean_CEO_Duality P_D_muu_rikos_4_2 P_BUSINESS_SOCIALDEG P_LN_EDULEVEL P_D_MARITAL_STATUS P_LN_CUM_SUM_DIVORCE P_LN_TOTALINCOME2 P_D_CUM_SUBSTANCE P_D_CUM_ALL_BUT_SUBS D_Muu_rikos_4 MALE LN_AGE BUSINESS_SOCIALDEG LN_EDULEVEL D_MARITAL_STATUS LN_CUM_SUM_DIVORCE LN_TOTALINCOME2 D_CUM_SUBSTANCE D_CUM_ALL_BUT_SUBS D_FMOB LN_NUM_POSITIONS Mean_OMAVARAISUUS2 Mean_LNTASE2 Mean_ROA2 Mean_LN_Boardsize Mean_Current_Ratio2 i.MAAKUNTA i.YEAR i.Industry_2002_3 [aweight=_webal], cluster(ID)
ereturn list r2_a
tabulate D_Vaste_talous_kaikki P_D_talous_kaikki_2 if Assets_3lk == 0

ebalance P_D_talous_kaikki_2 Mean_Mean_D_talous_kaikki Mean_Mean_D_muu_rikos_4 Mean_CEO_Duality P_D_muu_rikos_4_2 P_BUSINESS_SOCIALDEG P_LN_EDULEVEL P_D_MARITAL_STATUS P_LN_CUM_SUM_DIVORCE P_LN_TOTALINCOME2 P_D_CUM_SUBSTANCE P_D_CUM_ALL_BUT_SUBS D_Muu_rikos_4 MALE LN_AGE BUSINESS_SOCIALDEG LN_EDULEVEL D_MARITAL_STATUS LN_CUM_SUM_DIVORCE LN_TOTALINCOME2 D_CUM_SUBSTANCE D_CUM_ALL_BUT_SUBS D_FMOB LN_NUM_POSITIONS Mean_OMAVARAISUUS2 Mean_LNTASE2 Mean_ROA2 Mean_LN_Boardsize Mean_Current_Ratio2 i.YEAR i.Industry_2002_3 if Assets_3lk == 1, targets(3) maxiter(25)
reg D_Vaste_talous_kaikki P_D_talous_kaikki_2 Mean_Mean_D_talous_kaikki Mean_Mean_D_muu_rikos_4 Mean_CEO_Duality P_D_muu_rikos_4_2 P_BUSINESS_SOCIALDEG P_LN_EDULEVEL P_D_MARITAL_STATUS P_LN_CUM_SUM_DIVORCE P_LN_TOTALINCOME2 P_D_CUM_SUBSTANCE P_D_CUM_ALL_BUT_SUBS D_Muu_rikos_4 MALE LN_AGE BUSINESS_SOCIALDEG LN_EDULEVEL D_MARITAL_STATUS LN_CUM_SUM_DIVORCE LN_TOTALINCOME2 D_CUM_SUBSTANCE D_CUM_ALL_BUT_SUBS D_FMOB LN_NUM_POSITIONS Mean_OMAVARAISUUS2 Mean_LNTASE2 Mean_ROA2 Mean_LN_Boardsize Mean_Current_Ratio2 i.MAAKUNTA i.YEAR i.Industry_2002_3 [aweight=_webal], cluster(ID)
ereturn list r2_a
tabulate D_Vaste_talous_kaikki P_D_talous_kaikki_2 if Assets_3lk == 1

ebalance P_D_talous_kaikki_2 Mean_Mean_D_talous_kaikki Mean_Mean_D_muu_rikos_4 Mean_CEO_Duality P_D_muu_rikos_4_2 P_BUSINESS_SOCIALDEG P_LN_EDULEVEL P_D_MARITAL_STATUS P_LN_CUM_SUM_DIVORCE P_LN_TOTALINCOME2 P_D_CUM_SUBSTANCE P_D_CUM_ALL_BUT_SUBS D_Muu_rikos_4 MALE LN_AGE BUSINESS_SOCIALDEG LN_EDULEVEL D_MARITAL_STATUS LN_CUM_SUM_DIVORCE LN_TOTALINCOME2 D_CUM_SUBSTANCE D_CUM_ALL_BUT_SUBS D_FMOB LN_NUM_POSITIONS Mean_OMAVARAISUUS2 Mean_LNTASE2 Mean_ROA2 Mean_LN_Boardsize Mean_Current_Ratio2 i.YEAR i.Industry_2002_3 if Assets_3lk == 2, targets(3) maxiter(25)
reg D_Vaste_talous_kaikki P_D_talous_kaikki_2 Mean_Mean_D_talous_kaikki Mean_Mean_D_muu_rikos_4 Mean_CEO_Duality P_D_muu_rikos_4_2 P_BUSINESS_SOCIALDEG P_LN_EDULEVEL P_D_MARITAL_STATUS P_LN_CUM_SUM_DIVORCE P_LN_TOTALINCOME2 P_D_CUM_SUBSTANCE P_D_CUM_ALL_BUT_SUBS D_Muu_rikos_4 MALE LN_AGE BUSINESS_SOCIALDEG LN_EDULEVEL D_MARITAL_STATUS LN_CUM_SUM_DIVORCE LN_TOTALINCOME2 D_CUM_SUBSTANCE D_CUM_ALL_BUT_SUBS D_FMOB LN_NUM_POSITIONS Mean_OMAVARAISUUS2 Mean_LNTASE2 Mean_ROA2 Mean_LN_Boardsize Mean_Current_Ratio2 i.MAAKUNTA i.YEAR i.Industry_2002_3 [aweight=_webal], cluster(ID)
ereturn list r2_a
tabulate D_Vaste_talous_kaikki P_D_talous_kaikki_2 if Assets_3lk == 2

import sas using "W:\Tutkimusprojektit\Kirjanpito\Dokumentaatio\JAR\Datat\statadata_owner_011025.sas7bdat", clear
ebalance P_D_talous_kaikki_2 Mean_Mean_D_talous_kaikki Mean_Mean_D_muu_rikos_4 Mean_CEO_Duality MEAN_PERCENTAGEOWN MEAN_SUM_PERCENTAGEOWN2 P_D_muu_rikos_4_2 P_BUSINESS_SOCIALDEG P_LN_EDULEVEL P_D_MARITAL_STATUS P_LN_CUM_SUM_DIVORCE P_LN_TOTALINCOME2 P_D_CUM_SUBSTANCE P_D_CUM_ALL_BUT_SUBS D_Muu_rikos_4 MALE LN_AGE BUSINESS_SOCIALDEG LN_EDULEVEL D_MARITAL_STATUS LN_CUM_SUM_DIVORCE LN_TOTALINCOME2 D_CUM_SUBSTANCE D_CUM_ALL_BUT_SUBS D_FMOB LN_NUM_POSITIONS Mean_OMAVARAISUUS2 Mean_LNTASE2 Mean_ROA2 Mean_LN_Boardsize Mean_Current_Ratio2 i.YEAR i.Industry_2002_3, targets(3) maxiter(25)
reg D_Vaste_talous_kaikki P_D_talous_kaikki_2 Mean_Mean_D_talous_kaikki Mean_Mean_D_muu_rikos_4 Mean_CEO_Duality MEAN_PERCENTAGEOWN MEAN_SUM_PERCENTAGEOWN2 P_D_muu_rikos_4_2 P_BUSINESS_SOCIALDEG P_LN_EDULEVEL P_D_MARITAL_STATUS P_LN_CUM_SUM_DIVORCE P_LN_TOTALINCOME2 P_D_CUM_SUBSTANCE P_D_CUM_ALL_BUT_SUBS D_Muu_rikos_4 MALE LN_AGE BUSINESS_SOCIALDEG LN_EDULEVEL D_MARITAL_STATUS LN_CUM_SUM_DIVORCE LN_TOTALINCOME2 D_CUM_SUBSTANCE D_CUM_ALL_BUT_SUBS D_FMOB LN_NUM_POSITIONS Mean_OMAVARAISUUS2 Mean_LNTASE2 Mean_ROA2 Mean_LN_Boardsize Mean_Current_Ratio2 i.MAAKUNTA i.YEAR i.Industry_2002_3 [aweight=_webal], cluster(ID)
ereturn list r2_a
tabulate D_Vaste_talous_kaikki P_D_talous_kaikki_2

import sas using "W:\Tutkimusprojektit\Kirjanpito\Dokumentaatio\JAR\Datat\stata_talous_011025.sas7bdat", clear
ebalance P_D_talous_kaikki_2 P_D_muu_rikos_4_2 P_BUSINESS_SOCIALDEG P_LN_EDULEVEL P_D_MARITAL_STATUS P_LN_CUM_SUM_DIVORCE P_LN_TOTALINCOME2 P_D_CUM_SUBSTANCE P_D_CUM_ALL_BUT_SUBS D_Muu_rikos_4 MALE LN_AGE BUSINESS_SOCIALDEG LN_EDULEVEL D_MARITAL_STATUS LN_CUM_SUM_DIVORCE LN_TOTALINCOME2 D_CUM_SUBSTANCE D_CUM_ALL_BUT_SUBS D_FMOB LN_NUM_POSITIONS Mean_OMAVARAISUUS2 Mean_LNTASE2 Mean_ROA2 Mean_LN_Boardsize Mean_Current_Ratio2 i.YEAR i.Industry_2002_3 if Vaste_LN_sakot_talous_kaikki < ., targets(3) maxiter(25)
reg Vaste_LN_sakot_talous_kaikki P_D_talous_kaikki_2 P_D_muu_rikos_4_2 P_BUSINESS_SOCIALDEG P_LN_EDULEVEL P_D_MARITAL_STATUS P_LN_CUM_SUM_DIVORCE P_LN_TOTALINCOME2 P_D_CUM_SUBSTANCE P_D_CUM_ALL_BUT_SUBS D_Muu_rikos_4 MALE LN_AGE BUSINESS_SOCIALDEG LN_EDULEVEL D_MARITAL_STATUS LN_CUM_SUM_DIVORCE LN_TOTALINCOME2 D_CUM_SUBSTANCE D_CUM_ALL_BUT_SUBS D_FMOB LN_NUM_POSITIONS Mean_OMAVARAISUUS2 Mean_LNTASE2 Mean_ROA2 Mean_LN_Boardsize Mean_Current_Ratio2 i.MAAKUNTA i.YEAR i.Industry_2002_3 [aweight=_webal], cluster(ID)
ereturn list r2_a
tabulate D_Vaste_talous_kaikki P_D_talous_kaikki_2 if Vaste_LN_sakot_talous_kaikki < .

ebalance P_D_talous_kaikki_2 P_D_muu_rikos_4_2 P_BUSINESS_SOCIALDEG P_LN_EDULEVEL P_D_MARITAL_STATUS P_LN_CUM_SUM_DIVORCE P_LN_TOTALINCOME2 P_D_CUM_SUBSTANCE P_D_CUM_ALL_BUT_SUBS D_Muu_rikos_4 MALE LN_AGE BUSINESS_SOCIALDEG LN_EDULEVEL D_MARITAL_STATUS LN_CUM_SUM_DIVORCE LN_TOTALINCOME2 D_CUM_SUBSTANCE D_CUM_ALL_BUT_SUBS D_FMOB LN_NUM_POSITIONS Mean_OMAVARAISUUS2 Mean_LNTASE2 Mean_ROA2 Mean_LN_Boardsize Mean_Current_Ratio2 i.YEAR i.Industry_2002_3 if Vaste_LN_vankeus_talous_kaikki < ., targets(3) maxiter(25)
reg Vaste_LN_vankeus_talous_kaikki P_D_talous_kaikki_2 P_D_muu_rikos_4_2 P_BUSINESS_SOCIALDEG P_LN_EDULEVEL P_D_MARITAL_STATUS P_LN_CUM_SUM_DIVORCE P_LN_TOTALINCOME2 P_D_CUM_SUBSTANCE P_D_CUM_ALL_BUT_SUBS D_Muu_rikos_4 MALE LN_AGE BUSINESS_SOCIALDEG LN_EDULEVEL D_MARITAL_STATUS LN_CUM_SUM_DIVORCE LN_TOTALINCOME2 D_CUM_SUBSTANCE D_CUM_ALL_BUT_SUBS D_FMOB LN_NUM_POSITIONS Mean_OMAVARAISUUS2 Mean_LNTASE2 Mean_ROA2 Mean_LN_Boardsize Mean_Current_Ratio2 i.MAAKUNTA i.YEAR i.Industry_2002_3 [aweight=_webal], cluster(ID)
ereturn list r2_a
tabulate D_Vaste_talous_kaikki P_D_talous_kaikki_2 if Vaste_LN_vankeus_talous_kaikki < .


/* Table 5B */


import sas using "W:\Tutkimusprojektit\Kirjanpito\Dokumentaatio\JAR\Datat\stata_talous_011025.sas7bdat", clear
ebalance P_D_talous_kaikki_2 Mean_Mean_D_talous_kaikki Mean_Mean_D_muu_rikos_4 Mean_CEO_Duality P_D_muu_rikos_4_2 P_BUSINESS_SOCIALDEG P_LN_EDULEVEL P_D_MARITAL_STATUS P_LN_CUM_SUM_DIVORCE P_LN_TOTALINCOME2 P_D_CUM_SUBSTANCE P_D_CUM_ALL_BUT_SUBS D_Muu_rikos_4 MALE LN_AGE BUSINESS_SOCIALDEG LN_EDULEVEL D_MARITAL_STATUS LN_CUM_SUM_DIVORCE LN_TOTALINCOME2 D_CUM_SUBSTANCE D_CUM_ALL_BUT_SUBS D_FMOB LN_NUM_POSITIONS Mean_OMAVARAISUUS2 Mean_LNTASE2 Mean_ROA2 Mean_LN_Boardsize Mean_Current_Ratio2 i.YEAR i.Industry_2002_3, targets(3) maxiter(25)
areg D_Vaste_talous_kaikki P_D_talous_kaikki_2 Mean_Mean_D_talous_kaikki Mean_Mean_D_muu_rikos_4 Mean_CEO_Duality P_D_muu_rikos_4_2 P_BUSINESS_SOCIALDEG P_LN_EDULEVEL P_D_MARITAL_STATUS P_LN_CUM_SUM_DIVORCE P_LN_TOTALINCOME2 P_D_CUM_SUBSTANCE P_D_CUM_ALL_BUT_SUBS D_Muu_rikos_4 MALE LN_AGE BUSINESS_SOCIALDEG LN_EDULEVEL D_MARITAL_STATUS LN_CUM_SUM_DIVORCE LN_TOTALINCOME2 D_CUM_SUBSTANCE D_CUM_ALL_BUT_SUBS D_FMOB LN_NUM_POSITIONS Mean_OMAVARAISUUS2 Mean_LNTASE2 Mean_ROA2 Mean_LN_Boardsize Mean_Current_Ratio2 i.YearProvince [aweight=_webal], absorb(YearIndustry) cluster(ID)
tabulate D_Vaste_talous_kaikki P_D_talous_kaikki_2
areg P_D_talous_kaikki_2 i.YearProvince [aweight=_webal], absorb(YearIndustry)
areg P_D_talous_kaikki_2 Mean_Mean_D_talous_kaikki Mean_Mean_D_muu_rikos_4 Mean_CEO_Duality P_D_muu_rikos_4_2 P_BUSINESS_SOCIALDEG P_LN_EDULEVEL P_D_MARITAL_STATUS P_LN_CUM_SUM_DIVORCE P_LN_TOTALINCOME2 P_D_CUM_SUBSTANCE P_D_CUM_ALL_BUT_SUBS D_Muu_rikos_4 MALE LN_AGE BUSINESS_SOCIALDEG LN_EDULEVEL D_MARITAL_STATUS LN_CUM_SUM_DIVORCE LN_TOTALINCOME2 D_CUM_SUBSTANCE D_CUM_ALL_BUT_SUBS D_FMOB LN_NUM_POSITIONS Mean_OMAVARAISUUS2 Mean_LNTASE2 Mean_ROA2 Mean_LN_Boardsize Mean_Current_Ratio2 i.YearProvince [aweight=_webal], absorb(YearIndustry)

areg D_Vaste_talous_kaikki P_D_talous_kaikki_2 Mean_Mean_D_talous_kaikki Mean_Mean_D_muu_rikos_4 Mean_CEO_Duality P_D_muu_rikos_4_2 P_BUSINESS_SOCIALDEG P_LN_EDULEVEL P_D_MARITAL_STATUS P_LN_CUM_SUM_DIVORCE P_LN_TOTALINCOME2 P_D_CUM_SUBSTANCE P_D_CUM_ALL_BUT_SUBS D_Muu_rikos_4 MALE LN_AGE BUSINESS_SOCIALDEG LN_EDULEVEL D_MARITAL_STATUS LN_CUM_SUM_DIVORCE LN_TOTALINCOME2 D_CUM_SUBSTANCE D_CUM_ALL_BUT_SUBS D_FMOB LN_NUM_POSITIONS Mean_OMAVARAISUUS2 Mean_LNTASE2 Mean_ROA2 Mean_LN_Boardsize Mean_Current_Ratio2 [aweight=_webal], absorb(YearIndustryProvince) cluster(ID)
tabulate D_Vaste_talous_kaikki P_D_talous_kaikki_2
areg P_D_talous_kaikki_2 [aweight=_webal], absorb(YearIndustryProvince)
areg P_D_talous_kaikki_2 Mean_Mean_D_talous_kaikki Mean_Mean_D_muu_rikos_4 Mean_CEO_Duality P_D_muu_rikos_4_2 P_BUSINESS_SOCIALDEG P_LN_EDULEVEL P_D_MARITAL_STATUS P_LN_CUM_SUM_DIVORCE P_LN_TOTALINCOME2 P_D_CUM_SUBSTANCE P_D_CUM_ALL_BUT_SUBS D_Muu_rikos_4 MALE LN_AGE BUSINESS_SOCIALDEG LN_EDULEVEL D_MARITAL_STATUS LN_CUM_SUM_DIVORCE LN_TOTALINCOME2 D_CUM_SUBSTANCE D_CUM_ALL_BUT_SUBS D_FMOB LN_NUM_POSITIONS Mean_OMAVARAISUUS2 Mean_LNTASE2 Mean_ROA2 Mean_LN_Boardsize Mean_Current_Ratio2 [aweight=_webal], absorb(YearIndustryProvince)

areg D_Vaste_talous_kaikki P_D_talous_kaikki_2 Mean_Mean_D_talous_kaikki Mean_Mean_D_muu_rikos_4 Mean_CEO_Duality P_D_muu_rikos_4_2 P_BUSINESS_SOCIALDEG P_LN_EDULEVEL P_D_MARITAL_STATUS P_LN_CUM_SUM_DIVORCE P_LN_TOTALINCOME2 P_D_CUM_SUBSTANCE P_D_CUM_ALL_BUT_SUBS D_Muu_rikos_4 MALE LN_AGE BUSINESS_SOCIALDEG LN_EDULEVEL D_MARITAL_STATUS LN_CUM_SUM_DIVORCE LN_TOTALINCOME2 D_CUM_SUBSTANCE D_CUM_ALL_BUT_SUBS D_FMOB LN_NUM_POSITIONS Mean_OMAVARAISUUS2 Mean_LNTASE2 Mean_ROA2 Mean_LN_Boardsize Mean_Current_Ratio2 i.YEAR i.Industry_2002_3 [aweight=_webal], absorb(KUNTA) cluster(ID)
tabulate D_Vaste_talous_kaikki P_D_talous_kaikki_2
areg P_D_talous_kaikki_2 i.YEAR i.Industry_2002_3 [aweight=_webal], absorb(KUNTA)
areg P_D_talous_kaikki_2 Mean_Mean_D_talous_kaikki Mean_Mean_D_muu_rikos_4 Mean_CEO_Duality P_D_muu_rikos_4_2 P_BUSINESS_SOCIALDEG P_LN_EDULEVEL P_D_MARITAL_STATUS P_LN_CUM_SUM_DIVORCE P_LN_TOTALINCOME2 P_D_CUM_SUBSTANCE P_D_CUM_ALL_BUT_SUBS D_Muu_rikos_4 MALE LN_AGE BUSINESS_SOCIALDEG LN_EDULEVEL D_MARITAL_STATUS LN_CUM_SUM_DIVORCE LN_TOTALINCOME2 D_CUM_SUBSTANCE D_CUM_ALL_BUT_SUBS D_FMOB LN_NUM_POSITIONS Mean_OMAVARAISUUS2 Mean_LNTASE2 Mean_ROA2 Mean_LN_Boardsize Mean_Current_Ratio2 i.YEAR i.Industry_2002_3 [aweight=_webal], absorb(KUNTA)

ebalance P_D_talous_kaikki_2 Mean_Mean_D_talous_kaikki Mean_Mean_D_muu_rikos_4 Mean_CEO_Duality P_D_muu_rikos_4_2 P_BUSINESS_SOCIALDEG P_LN_EDULEVEL P_D_MARITAL_STATUS P_LN_CUM_SUM_DIVORCE P_LN_TOTALINCOME2 P_D_CUM_SUBSTANCE P_D_CUM_ALL_BUT_SUBS D_Muu_rikos_4 MALE LN_AGE BUSINESS_SOCIALDEG LN_EDULEVEL D_MARITAL_STATUS LN_CUM_SUM_DIVORCE LN_TOTALINCOME2 D_CUM_SUBSTANCE D_CUM_ALL_BUT_SUBS D_FMOB LN_NUM_POSITIONS Mean_OMAVARAISUUS2 Mean_LNTASE2 Mean_ROA2 Mean_LN_Boardsize Mean_Current_Ratio2 i.YEAR, targets(3) maxiter(25)
areg D_Vaste_talous_kaikki P_D_talous_kaikki_2 Mean_Mean_D_talous_kaikki Mean_Mean_D_muu_rikos_4 Mean_CEO_Duality P_D_muu_rikos_4_2 P_BUSINESS_SOCIALDEG P_LN_EDULEVEL P_D_MARITAL_STATUS P_LN_CUM_SUM_DIVORCE P_LN_TOTALINCOME2 P_D_CUM_SUBSTANCE P_D_CUM_ALL_BUT_SUBS D_Muu_rikos_4 MALE LN_AGE BUSINESS_SOCIALDEG LN_EDULEVEL D_MARITAL_STATUS LN_CUM_SUM_DIVORCE LN_TOTALINCOME2 D_CUM_SUBSTANCE D_CUM_ALL_BUT_SUBS D_FMOB LN_NUM_POSITIONS Mean_OMAVARAISUUS2 Mean_LNTASE2 Mean_ROA2 Mean_LN_Boardsize Mean_Current_Ratio2 i.YearIndustry [aweight=_webal], absorb(YearMunicipality) cluster(ID)
tabulate D_Vaste_talous_kaikki P_D_talous_kaikki_2
areg P_D_talous_kaikki_2 i.YearIndustry [aweight=_webal], absorb(YearMunicipality)
areg P_D_talous_kaikki_2 Mean_Mean_D_talous_kaikki Mean_Mean_D_muu_rikos_4 Mean_CEO_Duality P_D_muu_rikos_4_2 P_BUSINESS_SOCIALDEG P_LN_EDULEVEL P_D_MARITAL_STATUS P_LN_CUM_SUM_DIVORCE P_LN_TOTALINCOME2 P_D_CUM_SUBSTANCE P_D_CUM_ALL_BUT_SUBS D_Muu_rikos_4 MALE LN_AGE BUSINESS_SOCIALDEG LN_EDULEVEL D_MARITAL_STATUS LN_CUM_SUM_DIVORCE LN_TOTALINCOME2 D_CUM_SUBSTANCE D_CUM_ALL_BUT_SUBS D_FMOB LN_NUM_POSITIONS Mean_OMAVARAISUUS2 Mean_LNTASE2 Mean_ROA2 Mean_LN_Boardsize Mean_Current_Ratio2 i.YearIndustry [aweight=_webal], absorb(YearMunicipality)

ebalance P_D_talous_kaikki_2 Mean_Mean_D_talous_kaikki Mean_Mean_D_muu_rikos_4 Mean_CEO_Duality P_D_muu_rikos_4_2 P_BUSINESS_SOCIALDEG P_LN_EDULEVEL P_D_MARITAL_STATUS P_LN_CUM_SUM_DIVORCE P_LN_TOTALINCOME2 P_D_CUM_SUBSTANCE P_D_CUM_ALL_BUT_SUBS D_Muu_rikos_4 MALE LN_AGE BUSINESS_SOCIALDEG LN_EDULEVEL D_MARITAL_STATUS LN_CUM_SUM_DIVORCE LN_TOTALINCOME2 D_CUM_SUBSTANCE D_CUM_ALL_BUT_SUBS D_FMOB LN_NUM_POSITIONS Mean_OMAVARAISUUS2 Mean_LNTASE2 Mean_ROA2 Mean_LN_Boardsize Mean_Current_Ratio2 i.YEAR i.Industry_2002_3, targets(3) maxiter(25)
areg D_Vaste_talous_kaikki P_D_talous_kaikki_2 Mean_Mean_D_talous_kaikki Mean_Mean_D_muu_rikos_4 Mean_CEO_Duality P_D_muu_rikos_4_2 P_BUSINESS_SOCIALDEG P_LN_EDULEVEL P_D_MARITAL_STATUS P_LN_CUM_SUM_DIVORCE P_LN_TOTALINCOME2 P_D_CUM_SUBSTANCE P_D_CUM_ALL_BUT_SUBS D_Muu_rikos_4 MALE LN_AGE BUSINESS_SOCIALDEG LN_EDULEVEL D_MARITAL_STATUS LN_CUM_SUM_DIVORCE LN_TOTALINCOME2 D_CUM_SUBSTANCE D_CUM_ALL_BUT_SUBS D_FMOB LN_NUM_POSITIONS Mean_OMAVARAISUUS2 Mean_LNTASE2 Mean_ROA2 Mean_LN_Boardsize Mean_Current_Ratio2 [aweight=_webal], absorb(YearIndustryMunicipality) cluster(ID)
tabulate D_Vaste_talous_kaikki P_D_talous_kaikki_2
areg P_D_talous_kaikki_2 [aweight=_webal], absorb(YearIndustryMunicipality) 
areg P_D_talous_kaikki_2 Mean_Mean_D_talous_kaikki Mean_Mean_D_muu_rikos_4 Mean_CEO_Duality P_D_muu_rikos_4_2 P_BUSINESS_SOCIALDEG P_LN_EDULEVEL P_D_MARITAL_STATUS P_LN_CUM_SUM_DIVORCE P_LN_TOTALINCOME2 P_D_CUM_SUBSTANCE P_D_CUM_ALL_BUT_SUBS D_Muu_rikos_4 MALE LN_AGE BUSINESS_SOCIALDEG LN_EDULEVEL D_MARITAL_STATUS LN_CUM_SUM_DIVORCE LN_TOTALINCOME2 D_CUM_SUBSTANCE D_CUM_ALL_BUT_SUBS D_FMOB LN_NUM_POSITIONS Mean_OMAVARAISUUS2 Mean_LNTASE2 Mean_ROA2 Mean_LN_Boardsize Mean_Current_Ratio2 [aweight=_webal], absorb(YearIndustryMunicipality)


/* Table 5C */


import sas using "W:\Tutkimusprojektit\Kirjanpito\Dokumentaatio\JAR\Datat\stata_talous_011025.sas7bdat", clear
fvset base 7878 YearMunicipality

ebalance P_D_talous_kaikki_2 Score_muuttuja_2 P_D_muu_rikos_4_2 P_BUSINESS_SOCIALDEG P_LN_EDULEVEL P_D_MARITAL_STATUS P_LN_CUM_SUM_DIVORCE P_LN_TOTALINCOME2 P_D_CUM_SUBSTANCE P_D_CUM_ALL_BUT_SUBS D_Muu_rikos_4 MALE LN_AGE BUSINESS_SOCIALDEG LN_EDULEVEL D_MARITAL_STATUS LN_CUM_SUM_DIVORCE LN_TOTALINCOME2 D_CUM_SUBSTANCE D_CUM_ALL_BUT_SUBS D_FMOB LN_NUM_POSITIONS Mean_OMAVARAISUUS2 Mean_LNTASE2 Mean_ROA2 Mean_LN_Boardsize Mean_Current_Ratio2 i.YEAR i.Industry_2002_3, targets(3) maxiter(25)
areg D_Vaste_talous_kaikki P_D_talous_kaikki_2 Score_muuttuja_2 P_D_muu_rikos_4_2 P_BUSINESS_SOCIALDEG P_LN_EDULEVEL P_D_MARITAL_STATUS P_LN_CUM_SUM_DIVORCE P_LN_TOTALINCOME2 P_D_CUM_SUBSTANCE P_D_CUM_ALL_BUT_SUBS D_Muu_rikos_4 MALE LN_AGE BUSINESS_SOCIALDEG LN_EDULEVEL D_MARITAL_STATUS LN_CUM_SUM_DIVORCE LN_TOTALINCOME2 D_CUM_SUBSTANCE D_CUM_ALL_BUT_SUBS D_FMOB LN_NUM_POSITIONS Mean_OMAVARAISUUS2 Mean_LNTASE2 Mean_ROA2 Mean_LN_Boardsize Mean_Current_Ratio2 i.Industry_2002_3 [aweight=_webal], absorb(YearMunicipality) cluster(ID)
tabulate D_Vaste_talous_kaikki P_D_talous_kaikki_2

ebalance P_D_talous_kaikki_2 P_D_muu_rikos_4_2 P_BUSINESS_SOCIALDEG P_LN_EDULEVEL P_D_MARITAL_STATUS P_LN_CUM_SUM_DIVORCE P_LN_TOTALINCOME2 P_D_CUM_SUBSTANCE P_D_CUM_ALL_BUT_SUBS D_Muu_rikos_4 MALE LN_AGE BUSINESS_SOCIALDEG LN_EDULEVEL D_MARITAL_STATUS LN_CUM_SUM_DIVORCE LN_TOTALINCOME2 D_CUM_SUBSTANCE D_CUM_ALL_BUT_SUBS D_FMOB LN_NUM_POSITIONS Mean_OMAVARAISUUS2 Mean_LNTASE2 Mean_ROA2 Mean_LN_Boardsize Mean_Current_Ratio2 i.YEAR i.Industry_2002_3 if Score_muuttuja_2_3lk == 0, targets(3) maxiter(25)
areg D_Vaste_talous_kaikki P_D_talous_kaikki_2 P_D_muu_rikos_4_2 P_BUSINESS_SOCIALDEG P_LN_EDULEVEL P_D_MARITAL_STATUS P_LN_CUM_SUM_DIVORCE P_LN_TOTALINCOME2 P_D_CUM_SUBSTANCE P_D_CUM_ALL_BUT_SUBS D_Muu_rikos_4 MALE LN_AGE BUSINESS_SOCIALDEG LN_EDULEVEL D_MARITAL_STATUS LN_CUM_SUM_DIVORCE LN_TOTALINCOME2 D_CUM_SUBSTANCE D_CUM_ALL_BUT_SUBS D_FMOB LN_NUM_POSITIONS Mean_OMAVARAISUUS2 Mean_LNTASE2 Mean_ROA2 Mean_LN_Boardsize Mean_Current_Ratio2 i.Industry_2002_3 [aweight=_webal], absorb(YearMunicipality) cluster(ID)
tabulate D_Vaste_talous_kaikki P_D_talous_kaikki_2 if Score_muuttuja_2_3lk == 0

ebalance P_D_talous_kaikki_2 P_D_muu_rikos_4_2 P_BUSINESS_SOCIALDEG P_LN_EDULEVEL P_D_MARITAL_STATUS P_LN_CUM_SUM_DIVORCE P_LN_TOTALINCOME2 P_D_CUM_SUBSTANCE P_D_CUM_ALL_BUT_SUBS D_Muu_rikos_4 MALE LN_AGE BUSINESS_SOCIALDEG LN_EDULEVEL D_MARITAL_STATUS LN_CUM_SUM_DIVORCE LN_TOTALINCOME2 D_CUM_SUBSTANCE D_CUM_ALL_BUT_SUBS D_FMOB LN_NUM_POSITIONS Mean_OMAVARAISUUS2 Mean_LNTASE2 Mean_ROA2 Mean_LN_Boardsize Mean_Current_Ratio2 i.YEAR i.Industry_2002_3 if Score_muuttuja_2_3lk == 1, targets(3) maxiter(25)
areg D_Vaste_talous_kaikki P_D_talous_kaikki_2 P_D_muu_rikos_4_2 P_BUSINESS_SOCIALDEG P_LN_EDULEVEL P_D_MARITAL_STATUS P_LN_CUM_SUM_DIVORCE P_LN_TOTALINCOME2 P_D_CUM_SUBSTANCE P_D_CUM_ALL_BUT_SUBS D_Muu_rikos_4 MALE LN_AGE BUSINESS_SOCIALDEG LN_EDULEVEL D_MARITAL_STATUS LN_CUM_SUM_DIVORCE LN_TOTALINCOME2 D_CUM_SUBSTANCE D_CUM_ALL_BUT_SUBS D_FMOB LN_NUM_POSITIONS Mean_OMAVARAISUUS2 Mean_LNTASE2 Mean_ROA2 Mean_LN_Boardsize Mean_Current_Ratio2 i.Industry_2002_3 [aweight=_webal], absorb(YearMunicipality) cluster(ID)
tabulate D_Vaste_talous_kaikki P_D_talous_kaikki_2 if Score_muuttuja_2_3lk == 1

ebalance P_D_talous_kaikki_2 P_D_muu_rikos_4_2 P_BUSINESS_SOCIALDEG P_LN_EDULEVEL P_D_MARITAL_STATUS P_LN_CUM_SUM_DIVORCE P_LN_TOTALINCOME2 P_D_CUM_SUBSTANCE P_D_CUM_ALL_BUT_SUBS D_Muu_rikos_4 MALE LN_AGE BUSINESS_SOCIALDEG LN_EDULEVEL D_MARITAL_STATUS LN_CUM_SUM_DIVORCE LN_TOTALINCOME2 D_CUM_SUBSTANCE D_CUM_ALL_BUT_SUBS D_FMOB LN_NUM_POSITIONS Mean_OMAVARAISUUS2 Mean_LNTASE2 Mean_ROA2 Mean_LN_Boardsize Mean_Current_Ratio2 i.YEAR i.Industry_2002_3 if Score_muuttuja_2_3lk == 2, targets(3) maxiter(25)
areg D_Vaste_talous_kaikki P_D_talous_kaikki_2 P_D_muu_rikos_4_2 P_BUSINESS_SOCIALDEG P_LN_EDULEVEL P_D_MARITAL_STATUS P_LN_CUM_SUM_DIVORCE P_LN_TOTALINCOME2 P_D_CUM_SUBSTANCE P_D_CUM_ALL_BUT_SUBS D_Muu_rikos_4 MALE LN_AGE BUSINESS_SOCIALDEG LN_EDULEVEL D_MARITAL_STATUS LN_CUM_SUM_DIVORCE LN_TOTALINCOME2 D_CUM_SUBSTANCE D_CUM_ALL_BUT_SUBS D_FMOB LN_NUM_POSITIONS Mean_OMAVARAISUUS2 Mean_LNTASE2 Mean_ROA2 Mean_LN_Boardsize Mean_Current_Ratio2 i.Industry_2002_3 [aweight=_webal], absorb(YearMunicipality) cluster(ID)
tabulate D_Vaste_talous_kaikki P_D_talous_kaikki_2 if Score_muuttuja_2_3lk == 2

/*--*/

ebalance P_D_talous_kaikki_2 P_D_muu_rikos_4_2 P_BUSINESS_SOCIALDEG P_LN_EDULEVEL P_D_MARITAL_STATUS P_LN_CUM_SUM_DIVORCE P_LN_TOTALINCOME2 P_D_CUM_SUBSTANCE P_D_CUM_ALL_BUT_SUBS D_Muu_rikos_4 MALE LN_AGE BUSINESS_SOCIALDEG LN_EDULEVEL D_MARITAL_STATUS LN_CUM_SUM_DIVORCE LN_TOTALINCOME2 D_CUM_SUBSTANCE D_CUM_ALL_BUT_SUBS D_FMOB LN_NUM_POSITIONS Mean_OMAVARAISUUS2 Mean_LNTASE2 Mean_ROA2 Mean_LN_Boardsize Mean_Current_Ratio2 i.YEAR i.Industry_2002_3 if Score_muuttuja_2_3lk == 0 | Score_muuttuja_2_3lk == 2, targets(3) maxiter(25)
reg D_Vaste_talous_kaikki P_D_talous_kaikki_2 P_D_muu_rikos_4_2 P_BUSINESS_SOCIALDEG P_LN_EDULEVEL P_D_MARITAL_STATUS P_LN_CUM_SUM_DIVORCE P_LN_TOTALINCOME2 P_D_CUM_SUBSTANCE P_D_CUM_ALL_BUT_SUBS D_Muu_rikos_4 MALE LN_AGE BUSINESS_SOCIALDEG LN_EDULEVEL D_MARITAL_STATUS LN_CUM_SUM_DIVORCE LN_TOTALINCOME2 D_CUM_SUBSTANCE D_CUM_ALL_BUT_SUBS D_FMOB LN_NUM_POSITIONS Mean_OMAVARAISUUS2 Mean_LNTASE2 Mean_ROA2 Mean_LN_Boardsize Mean_Current_Ratio2 i.Industry_2002_3 i.YearMunicipality [aweight=_webal] if Score_muuttuja_2_3lk == 0, notable

predict low, score
estimates store low

reg D_Vaste_talous_kaikki P_D_talous_kaikki_2 P_D_muu_rikos_4_2 P_BUSINESS_SOCIALDEG P_LN_EDULEVEL P_D_MARITAL_STATUS P_LN_CUM_SUM_DIVORCE P_LN_TOTALINCOME2 P_D_CUM_SUBSTANCE P_D_CUM_ALL_BUT_SUBS D_Muu_rikos_4 MALE LN_AGE BUSINESS_SOCIALDEG LN_EDULEVEL D_MARITAL_STATUS LN_CUM_SUM_DIVORCE LN_TOTALINCOME2 D_CUM_SUBSTANCE D_CUM_ALL_BUT_SUBS D_FMOB LN_NUM_POSITIONS Mean_OMAVARAISUUS2 Mean_LNTASE2 Mean_ROA2 Mean_LN_Boardsize Mean_Current_Ratio2 i.Industry_2002_3 i.YearMunicipality [aweight=_webal] if Score_muuttuja_2_3lk == 2, notable

predict high, score
estimates store high
suest low high, cluster(ID)
test [low_mean]P_D_talous_kaikki_2 - [high_mean]P_D_talous_kaikki_2 = 0

drop low
drop high


/* Table 6A */


import sas using "W:\Tutkimusprojektit\Kirjanpito\Dokumentaatio\JAR\Datat\stata_talous_011025.sas7bdat", clear
fvset base 7878 YearMunicipality

ebalance P_D_talous_kaikki_2 P_D_muu_rikos_4_2 P_BUSINESS_SOCIALDEG P_LN_EDULEVEL P_D_MARITAL_STATUS P_LN_CUM_SUM_DIVORCE P_LN_TOTALINCOME2 P_D_CUM_SUBSTANCE P_D_CUM_ALL_BUT_SUBS D_Muu_rikos_4 MALE LN_AGE BUSINESS_SOCIALDEG LN_EDULEVEL D_MARITAL_STATUS LN_CUM_SUM_DIVORCE LN_TOTALINCOME2 D_CUM_SUBSTANCE D_CUM_ALL_BUT_SUBS D_FMOB LN_NUM_POSITIONS Mean_OMAVARAISUUS2 Mean_LNTASE2 Mean_ROA2 Mean_LN_Boardsize Mean_Current_Ratio2 i.YEAR i.Industry_2002_3, targets(3) maxiter(25)
areg D_Vaste_talous_kaikki LN_Talous_rikokset_lapsuus P_D_muu_rikos_4_2 P_BUSINESS_SOCIALDEG P_LN_EDULEVEL P_D_MARITAL_STATUS P_LN_CUM_SUM_DIVORCE P_LN_TOTALINCOME2 P_D_CUM_SUBSTANCE P_D_CUM_ALL_BUT_SUBS D_Muu_rikos_4 MALE LN_AGE BUSINESS_SOCIALDEG LN_EDULEVEL D_MARITAL_STATUS LN_CUM_SUM_DIVORCE LN_TOTALINCOME2 D_CUM_SUBSTANCE D_CUM_ALL_BUT_SUBS D_FMOB LN_NUM_POSITIONS Mean_OMAVARAISUUS2 Mean_LNTASE2 Mean_ROA2 Mean_LN_Boardsize Mean_Current_Ratio2 i.Industry_2002_3 [aweight=_webal], absorb(YearMunicipality) cluster(ID)
tabulate D_Vaste_talous_kaikki P_D_talous_kaikki_2

areg D_Vaste_talous_kaikki Talous_rikokset_lapsuus_High P_D_muu_rikos_4_2 P_BUSINESS_SOCIALDEG P_LN_EDULEVEL P_D_MARITAL_STATUS P_LN_CUM_SUM_DIVORCE P_LN_TOTALINCOME2 P_D_CUM_SUBSTANCE P_D_CUM_ALL_BUT_SUBS D_Muu_rikos_4 MALE LN_AGE BUSINESS_SOCIALDEG LN_EDULEVEL D_MARITAL_STATUS LN_CUM_SUM_DIVORCE LN_TOTALINCOME2 D_CUM_SUBSTANCE D_CUM_ALL_BUT_SUBS D_FMOB LN_NUM_POSITIONS Mean_OMAVARAISUUS2 Mean_LNTASE2 Mean_ROA2 Mean_LN_Boardsize Mean_Current_Ratio2 i.Industry_2002_3 [aweight=_webal], absorb(YearMunicipality) cluster(ID)
tabulate D_Vaste_talous_kaikki P_D_talous_kaikki_2

areg D_Vaste_talous_kaikki P_D_talous_kaikki_2 LN_Talous_rikokset_lapsuus P_D_muu_rikos_4_2 P_BUSINESS_SOCIALDEG P_LN_EDULEVEL P_D_MARITAL_STATUS P_LN_CUM_SUM_DIVORCE P_LN_TOTALINCOME2 P_D_CUM_SUBSTANCE P_D_CUM_ALL_BUT_SUBS D_Muu_rikos_4 MALE LN_AGE BUSINESS_SOCIALDEG LN_EDULEVEL D_MARITAL_STATUS LN_CUM_SUM_DIVORCE LN_TOTALINCOME2 D_CUM_SUBSTANCE D_CUM_ALL_BUT_SUBS D_FMOB LN_NUM_POSITIONS Mean_OMAVARAISUUS2 Mean_LNTASE2 Mean_ROA2 Mean_LN_Boardsize Mean_Current_Ratio2 i.Industry_2002_3 [aweight=_webal], absorb(YearMunicipality) cluster(ID)
tabulate D_Vaste_talous_kaikki P_D_talous_kaikki_2
test P_D_talous_kaikki_2 - LN_Talous_rikokset_lapsuus = 0

areg D_Vaste_talous_kaikki P_D_talous_kaikki_2 Talous_rikokset_lapsuus_High P_D_muu_rikos_4_2 P_BUSINESS_SOCIALDEG P_LN_EDULEVEL P_D_MARITAL_STATUS P_LN_CUM_SUM_DIVORCE P_LN_TOTALINCOME2 P_D_CUM_SUBSTANCE P_D_CUM_ALL_BUT_SUBS D_Muu_rikos_4 MALE LN_AGE BUSINESS_SOCIALDEG LN_EDULEVEL D_MARITAL_STATUS LN_CUM_SUM_DIVORCE LN_TOTALINCOME2 D_CUM_SUBSTANCE D_CUM_ALL_BUT_SUBS D_FMOB LN_NUM_POSITIONS Mean_OMAVARAISUUS2 Mean_LNTASE2 Mean_ROA2 Mean_LN_Boardsize Mean_Current_Ratio2 i.Industry_2002_3 [aweight=_webal], absorb(YearMunicipality) cluster(ID)
tabulate D_Vaste_talous_kaikki P_D_talous_kaikki_2
test P_D_talous_kaikki_2 - Talous_rikokset_lapsuus_High = 0

ebalance P_D_talous_kaikki_2 P_D_muu_rikos_4_2 P_BUSINESS_SOCIALDEG P_LN_EDULEVEL P_D_MARITAL_STATUS P_LN_CUM_SUM_DIVORCE P_LN_TOTALINCOME2 P_D_CUM_SUBSTANCE P_D_CUM_ALL_BUT_SUBS D_Muu_rikos_4 MALE LN_AGE BUSINESS_SOCIALDEG LN_EDULEVEL D_MARITAL_STATUS LN_CUM_SUM_DIVORCE LN_TOTALINCOME2 D_CUM_SUBSTANCE D_CUM_ALL_BUT_SUBS D_FMOB LN_NUM_POSITIONS Mean_OMAVARAISUUS2 Mean_LNTASE2 Mean_ROA2 Mean_LN_Boardsize Mean_Current_Ratio2 i.YEAR i.Industry_2002_3 if Talous_rikokset_lapsuus_Q == 1, targets(3) maxiter(25)
areg D_Vaste_talous_kaikki P_D_talous_kaikki_2 P_D_muu_rikos_4_2 P_BUSINESS_SOCIALDEG P_LN_EDULEVEL P_D_MARITAL_STATUS P_LN_CUM_SUM_DIVORCE P_LN_TOTALINCOME2 P_D_CUM_SUBSTANCE P_D_CUM_ALL_BUT_SUBS D_Muu_rikos_4 MALE LN_AGE BUSINESS_SOCIALDEG LN_EDULEVEL D_MARITAL_STATUS LN_CUM_SUM_DIVORCE LN_TOTALINCOME2 D_CUM_SUBSTANCE D_CUM_ALL_BUT_SUBS D_FMOB LN_NUM_POSITIONS Mean_OMAVARAISUUS2 Mean_LNTASE2 Mean_ROA2 Mean_LN_Boardsize Mean_Current_Ratio2 i.Industry_2002_3 [aweight=_webal], absorb(YearMunicipality) cluster(ID)
tabulate D_Vaste_talous_kaikki P_D_talous_kaikki_2 if Talous_rikokset_lapsuus_Q == 1

ebalance P_D_talous_kaikki_2 P_D_muu_rikos_4_2 P_BUSINESS_SOCIALDEG P_LN_EDULEVEL P_D_MARITAL_STATUS P_LN_CUM_SUM_DIVORCE P_LN_TOTALINCOME2 P_D_CUM_SUBSTANCE P_D_CUM_ALL_BUT_SUBS D_Muu_rikos_4 MALE LN_AGE BUSINESS_SOCIALDEG LN_EDULEVEL D_MARITAL_STATUS LN_CUM_SUM_DIVORCE LN_TOTALINCOME2 D_CUM_SUBSTANCE D_CUM_ALL_BUT_SUBS D_FMOB LN_NUM_POSITIONS Mean_OMAVARAISUUS2 Mean_LNTASE2 Mean_ROA2 Mean_LN_Boardsize Mean_Current_Ratio2 i.YEAR i.Industry_2002_3 if Talous_rikokset_lapsuus_Q == 2, targets(3) maxiter(25)
areg D_Vaste_talous_kaikki P_D_talous_kaikki_2 P_D_muu_rikos_4_2 P_BUSINESS_SOCIALDEG P_LN_EDULEVEL P_D_MARITAL_STATUS P_LN_CUM_SUM_DIVORCE P_LN_TOTALINCOME2 P_D_CUM_SUBSTANCE P_D_CUM_ALL_BUT_SUBS D_Muu_rikos_4 MALE LN_AGE BUSINESS_SOCIALDEG LN_EDULEVEL D_MARITAL_STATUS LN_CUM_SUM_DIVORCE LN_TOTALINCOME2 D_CUM_SUBSTANCE D_CUM_ALL_BUT_SUBS D_FMOB LN_NUM_POSITIONS Mean_OMAVARAISUUS2 Mean_LNTASE2 Mean_ROA2 Mean_LN_Boardsize Mean_Current_Ratio2 i.Industry_2002_3 [aweight=_webal], absorb(YearMunicipality) cluster(ID)
tabulate D_Vaste_talous_kaikki P_D_talous_kaikki_2 if Talous_rikokset_lapsuus_Q == 2

ebalance P_D_talous_kaikki_2 P_D_muu_rikos_4_2 P_BUSINESS_SOCIALDEG P_LN_EDULEVEL P_D_MARITAL_STATUS P_LN_CUM_SUM_DIVORCE P_LN_TOTALINCOME2 P_D_CUM_SUBSTANCE P_D_CUM_ALL_BUT_SUBS D_Muu_rikos_4 MALE LN_AGE BUSINESS_SOCIALDEG LN_EDULEVEL D_MARITAL_STATUS LN_CUM_SUM_DIVORCE LN_TOTALINCOME2 D_CUM_SUBSTANCE D_CUM_ALL_BUT_SUBS D_FMOB LN_NUM_POSITIONS Mean_OMAVARAISUUS2 Mean_LNTASE2 Mean_ROA2 Mean_LN_Boardsize Mean_Current_Ratio2 i.YEAR i.Industry_2002_3 if Talous_rikokset_lapsuus_Q == 3, targets(3) maxiter(25)
areg D_Vaste_talous_kaikki P_D_talous_kaikki_2 P_D_muu_rikos_4_2 P_BUSINESS_SOCIALDEG P_LN_EDULEVEL P_D_MARITAL_STATUS P_LN_CUM_SUM_DIVORCE P_LN_TOTALINCOME2 P_D_CUM_SUBSTANCE P_D_CUM_ALL_BUT_SUBS D_Muu_rikos_4 MALE LN_AGE BUSINESS_SOCIALDEG LN_EDULEVEL D_MARITAL_STATUS LN_CUM_SUM_DIVORCE LN_TOTALINCOME2 D_CUM_SUBSTANCE D_CUM_ALL_BUT_SUBS D_FMOB LN_NUM_POSITIONS Mean_OMAVARAISUUS2 Mean_LNTASE2 Mean_ROA2 Mean_LN_Boardsize Mean_Current_Ratio2 i.Industry_2002_3 [aweight=_webal], absorb(YearMunicipality) cluster(ID)
tabulate D_Vaste_talous_kaikki P_D_talous_kaikki_2 if Talous_rikokset_lapsuus_Q == 3

/*--*/

ebalance P_D_talous_kaikki_2 P_D_muu_rikos_4_2 P_BUSINESS_SOCIALDEG P_LN_EDULEVEL P_D_MARITAL_STATUS P_LN_CUM_SUM_DIVORCE P_LN_TOTALINCOME2 P_D_CUM_SUBSTANCE P_D_CUM_ALL_BUT_SUBS D_Muu_rikos_4 MALE LN_AGE BUSINESS_SOCIALDEG LN_EDULEVEL D_MARITAL_STATUS LN_CUM_SUM_DIVORCE LN_TOTALINCOME2 D_CUM_SUBSTANCE D_CUM_ALL_BUT_SUBS D_FMOB LN_NUM_POSITIONS Mean_OMAVARAISUUS2 Mean_LNTASE2 Mean_ROA2 Mean_LN_Boardsize Mean_Current_Ratio2 i.YEAR i.Industry_2002_3 if Talous_rikokset_lapsuus_Q == 1 | Talous_rikokset_lapsuus_Q == 3, targets(3) maxiter(25)
reg D_Vaste_talous_kaikki P_D_talous_kaikki_2 P_D_muu_rikos_4_2 P_BUSINESS_SOCIALDEG P_LN_EDULEVEL P_D_MARITAL_STATUS P_LN_CUM_SUM_DIVORCE P_LN_TOTALINCOME2 P_D_CUM_SUBSTANCE P_D_CUM_ALL_BUT_SUBS D_Muu_rikos_4 MALE LN_AGE BUSINESS_SOCIALDEG LN_EDULEVEL D_MARITAL_STATUS LN_CUM_SUM_DIVORCE LN_TOTALINCOME2 D_CUM_SUBSTANCE D_CUM_ALL_BUT_SUBS D_FMOB LN_NUM_POSITIONS Mean_OMAVARAISUUS2 Mean_LNTASE2 Mean_ROA2 Mean_LN_Boardsize Mean_Current_Ratio2 i.Industry_2002_3 i.YearMunicipality [aweight=_webal] if Talous_rikokset_lapsuus_Q == 1, notable

predict low, score
estimates store low

reg D_Vaste_talous_kaikki P_D_talous_kaikki_2 P_D_muu_rikos_4_2 P_BUSINESS_SOCIALDEG P_LN_EDULEVEL P_D_MARITAL_STATUS P_LN_CUM_SUM_DIVORCE P_LN_TOTALINCOME2 P_D_CUM_SUBSTANCE P_D_CUM_ALL_BUT_SUBS D_Muu_rikos_4 MALE LN_AGE BUSINESS_SOCIALDEG LN_EDULEVEL D_MARITAL_STATUS LN_CUM_SUM_DIVORCE LN_TOTALINCOME2 D_CUM_SUBSTANCE D_CUM_ALL_BUT_SUBS D_FMOB LN_NUM_POSITIONS Mean_OMAVARAISUUS2 Mean_LNTASE2 Mean_ROA2 Mean_LN_Boardsize Mean_Current_Ratio2 i.Industry_2002_3 i.YearMunicipality [aweight=_webal] if Talous_rikokset_lapsuus_Q == 3, notable

predict high, score
estimates store high
suest low high, cluster(ID)
test [low_mean]P_D_talous_kaikki_2 - [high_mean]P_D_talous_kaikki_2 = 0

drop low
drop high


/* Table 6B */


import sas using "W:\Tutkimusprojektit\Kirjanpito\Dokumentaatio\JAR\Datat\stata_t_muuttaneet_1k_011025.sas7bdat", clear
areg D_D_Vaste_talous_kaikki D_P_D_talous_kaikki_2 Talous_rikokset_muutos2 Talous_rikokset_muutos_ika_inter D_P_D_muu_rikos_4_2 D_P_BUSINESS_SOCIALDEG M_P_LN_EDULEVEL M_P_LN_CUM_SUM_DIVORCE M_P_LN_TOTALINCOME2 D_P_D_CUM_SUBSTANCE D_P_D_CUM_ALL_BUT_SUBS D_D_Muu_rikos_4 M_MALE D_BUSINESS_SOCIALDEG M_LN_EDULEVEL M_LN_CUM_SUM_DIVORCE M_LN_TOTALINCOME2 D_D_CUM_SUBSTANCE D_D_CUM_ALL_BUT_SUBS M_D_FMOB M_LN_NUM_POSITIONS i.muuttoika, absorb(SKunta) cluster(SKunta)
tabulate D_D_Vaste_talous_kaikki D_P_D_talous_kaikki_2


/* Table 7B */


import sas using "W:\Tutkimusprojektit\Kirjanpito\Dokumentaatio\JAR\Datat\stata_puolisodata_011025.sas7bdat", clear
reg LAG_D_Talous_kaikki LAG_Pa_D_Talous_kaikki LAG_Pa_D_muu_rikos_4 LAG_Pa_LN_EDULEVEL LAG_Pa_business_socialdeg LAG_Pa_LN_CUM_Sum_divorce LAG_Pa_LN_TOTALINCOME LAG_Pa_D_CUM_SUBSTANCE LAG_Pa_D_CUM_ALL_BUT_SUBS LAG_Pa_LN_AGE LAG_Pa_MALE LAG_D_Muu_rikos_4 LAG_LN_AGE LAG_MALE LAG_BUSINESS_SOCIALDEG LAG_LN_EDULEVEL LAG_LN_CUM_Sum_divorce LAG_LN_TOTALINCOME LAG_D_CUM_SUBSTANCE LAG_D_CUM_ALL_BUT_SUBS LAG_Same_municipality i.LAG_MAAKUNTA, cluster(ID)
ereturn list r2_a

reg E_FM_Muutos_dummy c.LN_Pa_Length##P_FM_Muutos_dummy LAG_D_Talous_kaikki LAG_Pa_D_Talous_kaikki LAG_Pa_D_muu_rikos_4 LAG_Pa_LN_EDULEVEL LAG_Pa_business_socialdeg LAG_Pa_LN_CUM_Sum_divorce LAG_Pa_LN_TOTALINCOME LAG_Pa_D_CUM_SUBSTANCE LAG_Pa_D_CUM_ALL_BUT_SUBS LAG_Pa_LN_AGE LAG_Pa_MALE LAG_D_Muu_rikos_4 LAG_LN_AGE LAG_MALE LAG_BUSINESS_SOCIALDEG LAG_LN_EDULEVEL LAG_LN_CUM_Sum_divorce LAG_LN_TOTALINCOME LAG_D_CUM_SUBSTANCE LAG_D_CUM_ALL_BUT_SUBS LAG_Same_municipality i.LAG_MAAKUNTA, cluster(ID)
ereturn list r2_a


/* Table 7C */


import sas using "W:\Tutkimusprojektit\Kirjanpito\Dokumentaatio\JAR\Datat\stata_talous_011025.sas7bdat", clear
ebalance P_D_talous_kaikki_2 Pa_D_Muu_rikos_4_2 Pa_D_CUM_SUBSTANCE Pa_D_CUM_ALL_BUT_SUBS Pa_LN_TOTALINCOME2 Pa_LN_EDULEVEL Pa_BUSINESS_SOCIALDEG Pa_LN_CUM_Sum_divorce Pa_LN_AGE P_D_muu_rikos_4_2 P_BUSINESS_SOCIALDEG P_LN_EDULEVEL P_D_MARITAL_STATUS P_LN_CUM_SUM_DIVORCE P_LN_TOTALINCOME2 P_D_CUM_SUBSTANCE P_D_CUM_ALL_BUT_SUBS D_Muu_rikos_4 MALE LN_AGE BUSINESS_SOCIALDEG LN_EDULEVEL LN_CUM_SUM_DIVORCE LN_TOTALINCOME2 D_CUM_SUBSTANCE D_CUM_ALL_BUT_SUBS D_FMOB LN_NUM_POSITIONS Mean_OMAVARAISUUS2 Mean_LNTASE2 Mean_ROA2 Mean_LN_Boardsize Mean_Current_Ratio2 i.YEAR i.Industry_2002_3 if Puoliso == 1, targets(3) maxiter(25)
areg D_Vaste_talous_kaikki P_D_talous_kaikki_2 Pa_D_Talous_kaikki_2 LN_Talous_rikokset_lapsuus2 P_D_muu_rikos_4_2 P_BUSINESS_SOCIALDEG P_LN_EDULEVEL P_D_MARITAL_STATUS P_LN_CUM_SUM_DIVORCE P_LN_TOTALINCOME2 P_D_CUM_SUBSTANCE P_D_CUM_ALL_BUT_SUBS D_Muu_rikos_4 MALE LN_AGE BUSINESS_SOCIALDEG LN_EDULEVEL LN_CUM_SUM_DIVORCE LN_TOTALINCOME2 D_CUM_SUBSTANCE D_CUM_ALL_BUT_SUBS D_FMOB LN_NUM_POSITIONS Mean_OMAVARAISUUS2 Mean_LNTASE2 Mean_ROA2 Mean_LN_Boardsize Mean_Current_Ratio2 i.Industry_2002_3 [aweight=_webal], absorb(YearMunicipality) cluster(ID)
tabulate D_Vaste_talous_kaikki P_D_talous_kaikki_2 if Puoliso == 1
tabulate D_Vaste_talous_kaikki Pa_D_Talous_kaikki_2 if Puoliso == 1

areg D_Vaste_talous_kaikki P_D_talous_kaikki_2 Pa_D_Talous_kaikki_2 LN_Talous_rikokset_lapsuus2 Pa_D_Muu_rikos_4_2 Pa_LN_EDULEVEL Pa_BUSINESS_SOCIALDEG Pa_LN_CUM_Sum_divorce Pa_LN_TOTALINCOME2 Pa_D_CUM_SUBSTANCE Pa_D_CUM_ALL_BUT_SUBS Pa_LN_AGE P_D_muu_rikos_4_2 P_BUSINESS_SOCIALDEG P_LN_EDULEVEL P_D_MARITAL_STATUS P_LN_CUM_SUM_DIVORCE P_LN_TOTALINCOME2 P_D_CUM_SUBSTANCE P_D_CUM_ALL_BUT_SUBS D_Muu_rikos_4 MALE LN_AGE BUSINESS_SOCIALDEG LN_EDULEVEL LN_CUM_SUM_DIVORCE LN_TOTALINCOME2 D_CUM_SUBSTANCE D_CUM_ALL_BUT_SUBS D_FMOB LN_NUM_POSITIONS Mean_OMAVARAISUUS2 Mean_LNTASE2 Mean_ROA2 Mean_LN_Boardsize Mean_Current_Ratio2 i.Industry_2002_3 [aweight=_webal], absorb(YearMunicipality) cluster(ID)
tabulate D_Vaste_talous_kaikki P_D_talous_kaikki_2 if Puoliso == 1
tabulate D_Vaste_talous_kaikki Pa_D_Talous_kaikki_2 if Puoliso == 1